﻿using FluentMigrator;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ETA.DbMigrations.V20140524
{
    [Migration(2014081025)]
    public class _05_WorkTypeInit : AutoReversingMigration
    {
        public override void Up()
        {
            var now = DateTime.Now;
            Insert.IntoTable("WorkType")
           .Row(new { WorkTypeId = "W101", WorkTypeName = "农业（种植.畜牧）", CreateDate = now, ModifyDate = now, IsDelete = 0 })
           .Row(new { WorkTypeId = "W102", WorkTypeName = "渔业（捕鱼.养殖）", CreateDate = now, ModifyDate = now, IsDelete = 0 })
           .Row(new { WorkTypeId = "W103", WorkTypeName = "建筑业（木工.瓦工.钢筋工）", CreateDate = now, ModifyDate = now, IsDelete = 0 })
           .Row(new { WorkTypeId = "W104", WorkTypeName = "食品加工（水产.一般食品）", CreateDate = now, ModifyDate = now, IsDelete = 0 })
           .Row(new { WorkTypeId = "W105", WorkTypeName = "纺织（纺纱.织布.染色）", CreateDate = now, ModifyDate = now, IsDelete = 0})
           .Row(new { WorkTypeId = "W106", WorkTypeName = "服装加工（缝纫.熨烫.质检）", CreateDate = now, ModifyDate = now, IsDelete = 0})
           .Row(new { WorkTypeId = "W107", WorkTypeName = "机械加工（车床.铣床）", CreateDate = now, ModifyDate = now, IsDelete = 0})
           .Row(new { WorkTypeId = "W108", WorkTypeName = "金属加工（电焊.铸造.锻造.冲压.钣金.涂装）", CreateDate = now, ModifyDate = now, IsDelete = 0})
           .Row(new { WorkTypeId = "W109", WorkTypeName = "电子业", CreateDate = now, ModifyDate = now, IsDelete = 0})
           .Row(new { WorkTypeId = "W110", WorkTypeName = "塑料加工", CreateDate = now, ModifyDate = now, IsDelete = 0 })
           .Row(new { WorkTypeId = "W111", WorkTypeName = "其他", CreateDate = now, ModifyDate = now, IsDelete = 0 });
        }

    }
}
